Computer Science for IGCSE & O level - Databases (Section 5 - No. 16)
What is the function of the `HAVING` clause in an SQL query?
To filter the results after the `GROUP BY` clause has been applied.
To sort the result set.
To specify the columns to be selected.
To filter the results before the `GROUP BY` clause.
解释
The `HAVING` clause is used to filter the results after the `GROUP BY` clause is applied, which allows filtering of the aggregated data.